package com.financing.platform.util;

public class SqlName {
	/**
	 * 查询所有用户组
	 */
	final static public String queryAllGroup = "group.queryAllGroup"; 
	
	/**
	 * 新增组信息
	 */
	final static public String insertGroup = "group.insertGroup";
	
	/**
	 * 更新组信息
	 */
	final static public String updateGroup = "group.updateGroup";
	
	/**
	 * 查询UUID
	 */
	final static public String queryUUID = "common.queryUUID";
	//系统合并
	/**
	 * 订单 -月销售统计
	 */
	final static public String queryOrderCountByMonth = "countInfo.queryOrderCountByMonth";
	/**
	 * 订单用户占认证比例
	 */
	final static public String queryOrderUserPer = "countInfo.queryOrderUserPer";
	/**
	 * 报表-运营统计报表
	 */
	final static public String queryOperateStatistics = "countInfo.queryOperateStatistics";
	final static public String queryFaUserRegisterByMonthCount = "countInfo.queryFaUserRegisterByMonthCount";
	final static public String queryFaUserRoleCount = "countInfo.queryFaUserRoleCount";
	final static public String queryFaAllUserCount = "countInfo.queryFaAllUserCount";
	//认证-理财师role占比
	final static public String queryFaUserRoleProportion = "countInfo.queryFaUserRoleProportion";
	//订单-理财师role占比
	final static public String queryOrderFaUserRoleProportion = "countInfo.queryOrderFaUserRoleProportion";
	/**
	 * 理财师总销量top 
	 */
	final static public String queryUserTotalSales = "countInfo.queryUserTotalSales";
	/**
	 * 查询组权限
	 */
	final static public String queryAccess = "accessControl.queryAccess";
	
	/**
	 * 添加组权限
	 */
	final static public String addAccessForGroup  = "accessControl.insertAccess";
	
	
	final static public String deleteAccess = "accessControl.deleteAccess";
	
	/**
	 * 更新用户信息
	 */
	final static public String updateUserInfo = "userInfo.updateUserInfo";
	
	/**
	 * 添加用户信息
	 */
	final static public String addUserInfo = "userInfo.addUserInfo";
	
	/**
	 * 查询单个用户信息
	 */
	final static public String queryUserInfo = "userInfo.queryUserInfo";
	
	/***
	 * 查询内部理财师信息邀请函统计
	 */
	final static public String querylcsstatistics = "userInfo.querylcsstatistics";
	
	/***
	 * 查询内部理财师信息系统分配统计
	 */
	final static public String querymanstatistics = "userInfo.querymanstatistics";
	
	/***
	 * 查询内部理财师详情列表 （理财师信息）
	 */
	final static public String querylcsDetailstatistics = "userInfo.querylcsDetailstatistics";
	/***
	 * 查询内部理财师信息邀请函统计
	 */
	final static public String countlcsDetailstatistics = "userInfo.countlcsDetailstatistics";
	/***
	 * 查询用户下子账户（内部理财师）
	 */
	final static public String queryUserInfoSubUserId = "userInfo.queryUserInfoSubUserId";
	/***
	 * 名单回访详情OK类A类B类C类D类
	 */
	final static public String queryVistDetail = "userInfo.queryVistDetail";
	/***
	 * 关注客户--内部理财师
	 */
	final static public String queryUserPhoneByManagerLCS = "userInfo.queryUserPhoneByManagerLCS";

	/**
	 * 查询用户组信息
	 */
	final static public String queryUserGroup = "userGroup.queryUserGroup";
	
	/**
	 * 删除用户所属组
	 */
	final static public String deleteUserGroup = "userGroup.deleteUserGroup";
	
	/**
	 * 新增用户所属组
	 */
	final static public String addUserGroup = "userGroup.addUserGroup";
	
	/**
	 * 查询所有满足条件的FA用户信息
	 */
	final static public String queryAllFaUser = "faUser.getFaUserList";
	
	/**
	 * 查询所有满足条件FA用户信息总数
	 */
	final static public String queryAllFaUserCount = "faUser.getFaUserListCount";
	
	/**
	 * 查询所有满足条件的理财师店铺FA用户信息
	 */
	final static public String queryAllShopFaUser = "faUser.getShopFaUserList";
	
	/**
	 * 查询所有满足条件理财师店铺FA用户信息总数
	 */
	final static public String queryAllShopFaUserCount = "faUser.getShopFaUserListCount";
	
	
	/**
	 *  查询 用户邀请人数及认证通过的
	 */
	final static public String queryFaUserListAuthPass = "faUser.queryFaUserListAuthPass";
	
	/**
	 *  查询 用户邀请人数及认证通过的总数
	 */
	final static public String queryFaUserListAuthPassCount = "faUser.queryFaUserListAuthPassCount";
	/**
	 *  查询 单个 用户邀请人数及认证通过的
	 */
	final static public String querySingleFaUserListAuthPass = "faUser.querySingleFaUserListAuthPass";
	
	/**
	 *  查询 单个用户邀请人数及认证通过的总数
	 */
	final static public String querySingleFaUserListAuthPassCount = "faUser.querySingleFaUserListAuthPassCount";
	
	final static public String getFaUserOrderCount = "faUser.getFaUserOrderCount";//人员订单数量
	
	
	/**
	 * 查询单个FA用户信息
	 */
	final static public String queryFaUser = "faUser.getFaUserList";
	final static public String queryFaUserView = "faUser.getFaUser";
	//无服务顾问的管理员
	final static public String queryFaUserNomanager = "faUser.queryFaUserNomanager";
	/**
	 * 跟新FA用户信息
	 */
	final static public String updateFaUserInfo = "faUser.updateFaUserInfo";
	final static public String updateFaUserInfoForMap = "faUser.updateFaUserInfoForMap";
	
	/**
	 * 查询需要审核的FA列表
	 */
	final static public String queryFaUserVerify = "faUser.queryFaUserVerify";
	/**
	 * 查询所有满足条件的FA用户信息 总数
	 */
	final static public String queryFaUserCount = "faUser.getFaUserListCount";
	/**
	 * 跟新FA用户状态
	 */
	final static public String updateFaUserStatus = "faUser.updateFaUserStatus";
	
	/**
	 * 添加产品
	 */
	final static public String insertProject = "project.insertProject";
	
	/**
	 *查询产品by名字
	 */
	final static public String searchProjectByName = "project.searchProjectByName";
	
	
	
	/**
	 * 添加产品扩展信息
	 */
	final static public String insertProjectExpand = "project.insertProjectExpand";
	
	/**
	 * 查询产品附件
	 */
	final static public String queryProductAccachement = "project.queryProductAccachement";
	
	/**
	 * 根据数据产品Id 查询产品信息
	 */
	final static public String queryProjectInfoByIds = "project.queryProjectInfoByIds";
	/**
	 * 根据数据产品Id 查询waichang产品信息
	 */
	final static public String queryOutProductInfoByIds = "project.queryOutProductInfoByIds";
	
	/**
	 * 销售时间过期的产品自动修改销售状态到募集结束
	 */
	final static public String autoUpdateSaleStatusTo05 = "project.autoUpdateSaleStatusTo05";
	
	/**
	 * 销售时间过期的产品自动修改销售状态到募集中
	 */
	final static public String autoUpdateSaleStatusTo03 = "project.autoUpdateSaleStatusTo03";
	
	/**
	 * 查询所有满足条件的产品
	 */
	final static public String queryAllProject ="project.getProjectList";
	
	/**
	 * 查询单个产品
	 */
	final static public String queryProject ="project.searchProjectById";
	
	/**
	 * 更新单个产品
	 */
	final static public String updateProject ="project.updateProjectById";
	/**
	 * 更新单个产品募集进度  说明
	 */
	final static public String addForegroundProductLog ="project.addForegroundProductLog";
	
	/**
	 * 更新单个产品(全字段修改)
	 */
	final static public String updateProjectFull ="project.updateProjectByIdFull";
	
	
	/**
	 * 更新单个产品扩展信息(全字段修改)
	 */
	final static public String updateProjectExpand ="project.updateProjectExpand";
	
	/**
	 * 查询单个产品扩展信息是否存在
	 */
	final static public String selectProjectExpand = "project.selectProjectExpand";
	
	/**
	 * 查询产品扩展信息
	 */
	final static public String getProductProfitRebateLists ="project.getProductProfitRebateLists";

	/**
	 * 根据code查询名称
	 */
	final static public String queryPnameByCode ="project.queryPnameByCode";
	
	/**
	 * 查询所有action
	 */
	final static public String queryAllAction = "action.queryAllAction";
	
	/**
	 * 添加action
	 */
	final static public String addAction = "action.addAction";
	
	/**
	 * 查询ation详细信息
	 */
	final static public String queryAction = "action.queryAction";
	
	/**
	 * 查询订单列表和详情
	 */
	final static public String queryOrder = "order.queryOrder";
	
	/**
	 * 产品成立的时候查询需要发送短信的FA
	 */
	final static public String queryNeedSendSMSFAId = "order.queryNeedSendSMSFAId";
	
	/**
	 * 插入订单改变订单状态
	 */
	final static public String addForUpdateOrder = "order.insertOrder";
	
	/**
	 * 更新订单状态
	 */
	final static public String  updateOrder = "order.updateOrder";
	
	/**
	 * 查询订单合同
	 */
	final static public String queryOrderContract = "order.queryOrderContract";
	/**
	 * 查询订单-昨日我的团队的业绩月度业绩
	 */
	final static public String queryOrderOwnerUserCountAmount = "order.queryOrderOwnerUserCountAmount";

	/**
	 * 插入产品年化益率表
	 */
	final static public String insertProjectAnnualRevenue = "projectAnnualRevenue.insertProjectAnnualRevenue";
	
	/**
	 * 查询产品年化益率信息
	 */
	final static public String searchProjectAnnualRevenueByPid = "projectAnnualRevenue.searchProjectAnnualRevenueByPid";
	
	/**
	 * 删除产品年化益率信息
	 */
	final static public String deleteProjectAnnualRevenueByid = "projectAnnualRevenue.deleteProjectAnnualRevenueByid";
	
	/**
	 * 修改年化益(错误 #1137: 后台-产品结束金额未填写保存显示原募集规模后再次修改募集规模，结束金额仍然显示原来的)
	 */
	final static public String updateProjectAnnualRevenueByendAmount = "projectAnnualRevenue.updateProjectAnnualRevenueByendAmount";
	
	
	/**
	 * 插入产品返佣表
	 */
	final static public String insertProjectRabate = "projectRabate.insertProjectRabate";
	/**
	 * 查询产品返佣表
	 */
	final static public String searchProjectRabateByPid = "projectRabate.searchProjectRabateByPid";
	
	/**
	 * 添加产品点评信息
	 */
	final static public String insertProjectComments = "projectComments.insertProjectComments";
	
	/**
	 * 查询产品点评信息
	 */
	final static public String searchProjectCommentsByPid = "projectComments.searchProjectCommentsByPid";
	
	/**
	 * 添加风险信息
	 */
	final static public String insertProjectRisk = "projectRiskDTO.insertProjectRisk";
	/**
	 * 添加风险信息
	 */
	final static public String searchProjectRiskByPid = "projectRiskDTO.searchProjectRiskByPid";
	
	/**
	 * 添加产品推荐
	 */
	final static public String addProductRecommend = "productRecommend.addProductRecommend";
	
	/**
	 * 查询当前产品被推荐信息
	 */
	final static public String queryRecommendList = "productRecommend.queryRecommendList";
	
	/**
	 * 查询FA证书信息
	 */
	final static public String queryFaUserAuthByFaId = "faUserAuth.queryFaUserAuthByFaId";
	
	/**
	 * 查询订单所有信息
	 */
	final static public String queryOrderAllInfo = "order.queryOrderAllInfo";
	
	/**
	 * 根据产品查询订单
	 */
	final static public String queryOrderByProId="order.queryOrderByProId";
	/**
	 *count 根据产品查询订单
	 */
	final static public String countOrderByProId="order.countOrderByProId";
	
	/**
	 * 查询订单列表总数
	 */
	final static public String queryOrderAllInfoCount = "order.queryOrderAllInfoCount";
	
	/**
	 * 根据产品Id 查询订单
	 */
	final static public String queryOrderForUserId = "order.queryOrderForUserId";
	/**
	 * 根据产品Id 查询订单
	 */
	final static public String updateOrderDefriendStatus = "order.updateOrderDefriendStatus";
	
	/**
	 * 根据产品Id 查询订单
	 */
	final static public String queryOrderFormProjectId = "order.queryOrderFormProjectId";
	
	
	
	/**
	 * 查询开关信息
	 */
	final static public String querySwitch = "switch.switchList";
	
	/**
	 * 更新开关状态
	 */
	final static public String updateSwitch ="switch.updateSwitch";
	
	/**
	 * 添加开关
	 */
	final static public String addSwitch = "switch.addSwitch";
	
	/**
	 * 订单取消
	 */
	final static public String updateOrderCancel = "order.updateOrderCancel";
	
	/**
	 * 更新fa权限
	 */
	final static public String faUserAuthUpdate ="faUserAuth.faUserAuthUpdate";
	final static public String faUserAuthUpdateAll ="faUserAuth.faUserAuthUpdateAll";
	final static public String faUserAuthAdd = "faUserAuth.faUserAuthAdd";
	final static public String faUserAuthQuery = "faUserAuth.faUserAuthQuery";
	
	/**
	 * 跟新fa权限
	 */
	final static public String faUserCertUpdate = "faUserCert.faUserCertUpdate";
	
	
	/**
	 * 查询fa证书信息
	 */
	final static public String queryFaUserCertByFaId = "faUserCert.queryFaUserCertByFaId";
	
	/**
	 * 查询评论表信息
	 */
	final static public String discussList = "discuss.discussList";
	
	/**
	 * 更新评论状态
	 */
	final static public String updateDiscuss = "discuss.updateDiscuss";
	
	/**
	 * 查询信息主体列表
	 */
	final static public String queryMesaage = "message.queryMesaage";
	
	/**
	 * 添加消息主体信息
	 */
	final static public String addMessage = "message.addMessage";
	
	/**
	 * 查询短信息列表
	 */
	final static public String queryMessageSms = "messageSms.queryMessageSms";
	
	/**
	 * 更新短信状态
	 */
	final static public String updateMessageSms = "messageSms.updateMessageSms";
	
	/**
	 * 添加短信息
	 */
	final static public String addMessageSms = "messageSms.addMessageSms";
	
	/**
	 * 查询站内消息
	 */
	final static public String queryMessageNote = "messageNote.queryMessageNote";
	
	/**
	 * 添加站内消息
	 */
	final static public String addMessageNote = "messageNote.addMessageNote";
	
	/**
	 * 审核用户为机构总账户
	 */
	final static public String makeCompanyUser = "faUser.makeCompanyUser";
	
	/**
	 * 添加机构账户邀请码
	 */
	final static public String addCompanyInvitationCode = "companyInvitationCode.addCompanyInvitationCode";
	
	/**
	 * 添加机构
	 */
	final static public String addCompany = "faUser.addCompany";
	
	/**
	 * 更新机构状态
	 */
	final static public String updateCompany = "faUser.updateCompany";
	
	/**
	 * 查询机构列表
	 */
	final static public String queryCompany = "faUser.queryCompany";
	
	/**
	 * 产品机构关联
	 */
	final static public String addCorpProject = "project.addCorpProject";
	
	/**
	 * 查询所有FAID
	 */
	final static public String queryFaAllId = "faUser.queryFaAllId";
	
	/**
	 * 查询产品机构关联ID
	 */
	final static public String queryCorpProjectId = "project.queryCorpProjectId";
	
	/**
	 * 添加系统日志
	 */
	final static public String addLogs = "logs.addLog";
	
	/**
	 * 添加用户账户
	 */
	final static public String addUserAccount = "userAccount.addUserAccount";
	
	/**
	 * 更新用户账户
	 */
	final static public String updateUserAccount = "userAccount.updateUserAccount";
	
	/**
	 * 新增账户资金
	 */
	final static public String addAccountMount= "userAccount.addAccountMount";
	
	/**
	 * 提现失败-更新用户账户
	 */
	final static public String updateAccountForWithdraw = "userAccount.updateAccountForWithdraw";
	
	/**
	 * 解冻红包资金
	 */
	final static public String thawingAccountMount = "userAccount.thawingAccountMount";
	
	/**
	 * 修改产品评论状态
	 */
	final static public String updateProjectComment = "projectComments.updateProjectComment";
	
	/**
	 * 添加产品账号信息
	 */
	final static public String addProjectAccount = "projectAccount.addProjectAccount";
	
	/**
	 * 查询产品账号信息
	 */
	final static public String queryProjectAccount = "projectAccount.queryProjectAccount";
	
	/**
	 * 添加资讯
	 */
	final static public String addNews = "news.addNews";
	
	/**
	 * 资讯信息列表
	 */
	final static public String newsList = "news.newsList";
	
	/**
	 * 资讯信息列表
	 */
	final static public String newsListCount = "news.newsListCount";
	
	/**
	 * 删除资讯信息
	 */
	final static public String newsDelete = "news.newsDelete";
	
	/**
	 * 更新资讯信息
	 */
	final static public String updateNews = "news.updateNews";
	
	/**
	 * 添加返佣入账明细
	 */
	final static public String addUserAccountDetail = "userAccount.addUserAccountDetail";
	
	/**
	 * 添加账户明细
	 */
	final static public String insertUserAccountDetail = "userAccount.insertUserAccountDetail";
	
	
	/**
	 * 查询账户ID
	 */
	final static public String getUserAccountId = "userAccount.getUserAccountId";
	
	/**
	 * 更新产品购买信息
	 */
	final static public String updateAllSubscription = "project.updateAllSubscription";
	
	/**
	 * 删除产品账号信息
	 */
	final static public String deleteProjectAccount = "projectAccount.deleteProjectAccount";
	
	/**
	 * 删除产品返佣信息
	 */
	final static public String deleteProjectRabate = "projectRabate.deleteProjectRabate";
	
	/**
	 * 删除产品基本信息
	 */
	final static public String deleteProject = "project.deleteProject";
	
	/**
	 * 删除产品
	 */
	final static public String deleteRecommend = "productRecommend.deleteRecommend";
	
	/**
	 * 删除产品安全信息
	 */
	final static public String deleteProjectRisk = "projectRiskDTO.deleteProjectRisk";
	
	/**
	 * 添加产品附件
	 */
	final static public String addProductAccachement = "project.addProductAccachement";
	
	/**
	 * 查询邮件信息列表
	 */
	final static public String queryMessageMail = "messageMail.queryMessageMail";
	
	/**
	 * 添加邮件
	 */
	final static public String addMessageMail = "messageMail.addMessageMail";
	
	/**
	 * 更新邮件状态
	 */
	final static public String updateMessageMail = "messageMail.updateMessageMail";
	
	/**
	 * 删除产品附件信息
	 */
	final static public String deleteProductAttachment = "project.deleteProductAttachment";
	
	/**
	 * 查询注册总人数
	 */
	final static public String registPersonTotal = "countInfo.registPersonTotal";
	
	/**
	 * 查询转发总量
	 */
	final static public String forWardNumTotal = "countInfo.forWardNumTotal";
	
	/**
	 * 查询审核通过的总人数
	 */
	final static public String registVerifyPassTotal = "countInfo.registVerifyPassTotal";
	
	/**
	 * 产线审核未通过或者未审核的人数
	 */
	final static public String registVerifyNoPassTotal  = "countInfo.registVerifyNoPassTotal";
	
	/**
	 * 添加统计信息
	 */
	final static public String insertCountInfo = "countInfo.insertCountInfo";
	/**
	 * 添加统计信息
	 */
	final static public String queryCountInfo = "countInfo.queryCountInfo";
	/**
	 * 添加统计信息
	 */
	final static public String updateCountInfo = "countInfo.updateCountInfo";
	/**
	 * 统计注册用户量
	 */
	final static public String registPersonCount = "countInfo.registPersonCount";
	/**
	 * 统计注册审核通过人数
	 */
	final static public String registVerifyPass = "countInfo.registVerifyPass";
	/**
	 * 统计理财师未通过认证人数
	 */
	final static public String registVerifyNoPass = "countInfo.registVerifyNoPass";
	
	/**
	 * 统计订单预约成功的人数 
	 */
	final static public String orderPerSuccessPerson = "countInfo.orderPerSuccessPerson";
	
	/**
	 * 统计订单预约失败的人数 
	 */
	final static public String orderPerFailPerson = "countInfo.orderPerFailPerson";
	
	/**
	 * 统计订单返佣成功的人数
	 */
	final static public String orderRebateSuccessPerson = "countInfo.orderRebateSuccessPerson";
	
	/**
	 * 统计订单取消的人数 
	 */
	final static public String orderCancelPerson = "countInfo.orderCancelPerson";
	
	/**
	 * 统计订单预约成功的笔数
	 */
	final static public String orderPerSuccess = "countInfo.orderPerSuccess";
	
	/**
	 * 统计订单预约失败的笔数
	 */
	final static public String orderPerFail = "countInfo.orderPerFail";
	
	/**
	 * 统计订单返佣成功的笔数
	 */
	final static public String productOrderRebateSuccess = "countInfo.productOrderRebateSuccess";
	
	/**
	 * 统计订单取消的笔数
	 */
	final static public String productOrderCancel = "countInfo.productOrderCancel";
	
	/**
	 * 订单预约人数
	 */
	final static public String orderPerPerson = "countInfo.orderPerPerson";
	
	/**
	 * 订单预约数
	 */
	final static public String orderPer  =  "countInfo.orderPer";
	
	/**
	 * 转发数
	 */
	final static public String forWardNum = "countInfo.forWardNum";
	
	/**
	 * 报表-订单清单
	 */
	final static public String OrderDetailedList = "countInfo.OrderDetailedList";
	
	/**
	 * 报表-订单清单数
	 */
	final static public String OrderDetailedListCount = "countInfo.OrderDetailedListCount";
	/**
	 * 报表-认证用户清单
	 */
	final static public String queryAuthUserDetailedList = "countInfo.queryAuthUserDetailedList";
	/**
	 * 报表-认证用户清单数
	 */
	final static public String queryAuthUserDetailedListCount = "countInfo.queryAuthUserDetailedListCount";
	
	/**
	 * 报表-销售业绩-订单
	 */
	final static public String querySalesPerformanceOrder = "countInfo.querySalesPerformanceOrder";
	/**
	 * 报表-销售业绩-注册
	 */
	final static public String querySalesPerformanceRegister = "countInfo.querySalesPerformanceRegister";
	/**
	 * 报表-销售业绩-回访
	 */
	final static public String querySalesPerformanceVisit = "countInfo.querySalesPerformanceVisit";
	
	/**
	 * 报表-销售业绩-名下理财师数
	 */
	final static public String queryAccountFinancialCount = "countInfo.queryAccountFinancialCount";
	
	
	
	/**
	 * 添加订单流水
	 */
	final static public String addOrderFlow = "orderflow.addOrderFlow";

	/**
	 * 查询订单流水
	 */
	final static public String queryOrderFlowList = "orderflow.queryOrderFlowList";

	/**
	 * 查询订单流水
	 */
	final static public String updateOrderFlow = "orderflow.updateOrderFlow";
	
	/**
	 * 添加回访记录
	 */
	final static public String addVisit = "faUserVisit.addVisit";
	
	/**
	 * 查询回访记录
	 */
	final static public String queryVisit = "faUserVisit.queryVisit";
	final static public String queryFaUserVisitStatistic = "faUserVisit.queryFaUserVisitStatistic";//查询回访统计记录
	
	
	/**
	 * 查询活动红包
	 */
	final static public String queryActiviteGift = "activitieGift.queryActiviteGift";
	
	final static public String queryActivitiesSDHDGift = "activitieGift.queryActivitiesSDHDGift";
	
	/**
	 * 根据活动code查询红包
	 */
	final static public String queryActivitiesGiftByCode = "activitieGift.queryActivitiesGiftByCode";
	
	/**
	 * 查询百万计划红包
	 */
	final static public String queryActivitiesMollionsWealthGift = "activitieGift.queryActivitiesMollionsWealthGift";
	
	/**
	 * 更新活动红包
	 */
	final static public String updateActiviteGift = "activitieGift.updateActiviteGift";
	
	/**
	 * 添加活动礼品
	 */
	final static public String addActivitieGift = "activitieGift.addActivitieGift";
	
	/**
	 * 添加公共活动信息
	 */
	final static public String addPublicActivities = "publicActivities.addPublicActivities"; 
	
	/**
	 * 更新公共活动信息
	 */
	final static public String updatePublicActivities = "publicActivities.updatePublicActivities";
	
	/**
	 * 查询公共活动信息
	 */
	final static public String queryPublicActivities = "publicActivities.queryPublicActivities";
	
	/**
	 * 查询公共活动信息列表
	 */
	final static public String publicActivitiesList = "publicActivities.publicActivitiesList";
	
	/**
	 * 查询公共活动信息列表count
	 */
	final static public String publicActivitiesListCount = "publicActivities.publicActivitiesListCount";
	
	/**
	 * 查询公共活动报名人
	 */
	final static public String  queryPublicActivitiesPerson ="publicActivitiesPerson.queryPublicActivitiesPerson";
	
	/**
	 * 查询反馈意见
	 */
	final static public String userFeedBackList ="fpUserFeedBack.userFeedBackList";
	final static public String userFeedBackListCount ="fpUserFeedBack.userFeedBackListCount";
	
	/**
	 * 更新反馈意见读取状态
	 */
	final static public String updateFeedBack = "fpUserFeedBack.updateFeedBack";
	
	/**
	 * 产品发布列表
	 */
	final static public String productForPublishList = "project.productForPublishList";
	
	/**
	 * 查询产品列表总数
	 */
	final static public String productForPublishListCount= "project.productForPublishListCount";
	
	/**
	 * 前台API数据配置列表
	 */
	final static public String apiSettingList ="apiSetting.apiSettingList";
	
	/**
	 * 更新API数据配置
	 */
	final static public String updateApiSetting = "apiSetting.updateApiSetting";
	
	/**
	 * 添加前台API数据配置
	 */
	final static public String addApiSetting = "apiSetting.addApiSetting";
	
	/**
	 * 添加产品公司
	 */
	final static public String addProjectCompany = "projectCompany.addProjectCompany";
	/**
	 * 修改产品公司
	 */
	final static public String updateProjectCompany = "projectCompany.updateProjectCompany";
	/**
	 * 查询产品公司详细
	 */
	final static public String queryProjectCompanyInfo = "projectCompany.queryProjectCompanyInfo";
	/**
	 * 查询产品公司列表
	 */
	final static public String queryProjectCompany = "projectCompany.queryProjectCompany";
	/**
	 * 查询产品公司列表总
	 */
	final static public String queryProjectCompanyCount = "projectCompany.queryProjectCompanyCount";
	/**
	 * 查询产品公司列表总
	 */
	final static public String delProjectCompany = "projectCompany.delProjectCompany";
	/**
	 * 查询订阅信息列表
	 */
	final static public String queryInfoSubscribe = "infoSubscribe.queryInfoSubscribe";
	
	/**
	 * 查询订阅信息列表数
	 */
	final static public String queryInfoSubscribeCount = "infoSubscribe.queryInfoSubscribeCount";
	
	/**
	 * 添加银行卡
	 */
	final static public String bankCardAdd = "bankCard.insertBankCard";
	/**
	 * 查询银行卡
	 */
	final static public String bankCardList = "bankCard.queryBankCardList";
	final static public String bankCardListCount = "bankCard.queryBankCardListCount";
	/**
	 * 删除银行卡
	 */
	final static public String bankCardDelete = "bankCard.deleteBankCard";
	/**
	 * 添加账户提现记录
	 */
	final static public String accountWithdrawAdd = "accountWithdraw.insertAccountWithdraw";
	
	/**
	 * 查询账户提现列表
	 */
	final static public String accountWithdrawList = "accountWithdraw.queryAccountWithdrawList";
	/**
	 * 查询账户提现列表
	 */
	final static public String accountWithdrawListCount = "accountWithdraw.queryAccountWithdrawListCount";
	/**
	 * 修改账户提现状态
	 */
	final static public String accountWithdrawUpdate = "accountWithdraw.updateAccountWithdraw";
	/**
	 * 查询提现明细
	 */
	final static public String accountWithdrawInfo = "accountWithdraw.queryAccountWithdraw";

	/**
	 * 添加广告
	 */
	final static public String addAdvert = "advert.addAdvert"; 
	/**
	 * 查询广告列表
	 */
	final static public String queryAdvert = "advert.queryAdvert";
	final static public String queryAdvertRecommend = "advert.queryAdvertRecommend"; 
	/**
	 * 查询广告信息
	 */
	final static public String queryAdvertInfo = "advert.queryAdvertInfo"; 
	/**
	 * 修改广告
	 */
	final static public String updateAdvert = "advert.updateAdvert"; 
	/**
	 * 广告数
	 */
	final static public String queryAdvertCount = "advert.queryAdvertCount";
	final static public String queryAdvertRecommendCount = "advert.queryAdvertRecommendCount"; 

	/**
	 * 友情链接查询列表
	 */
	final static public String queryListFriendshipLink = "fpFriendshipLink.queryList";
	
	/**
	 * 友情链接查询对象
	 */
	final static public String getFriendshipLink = "fpFriendshipLink.get";
	
	/**
	 * 友情链接添加
	 */
	final static public String addFriendshipLink = "fpFriendshipLink.add";
	
	/**
	 * 友情链接更新
	 */
	final static public String updateFriendshipLink = "fpFriendshipLink.update";
	
	/**
	 * 友情链接删除
	 */
	final static public String deleteFriendshipLink = "fpFriendshipLink.delete";

	
	/**
	 * 私募数据
	 */
	final static public String fpFundAwkwardness = "fpFundAwkwardness.getFpFundAwkwardness";
	final static public String insertFpFundAwkwardness = "fpFundAwkwardness.insertFpFundAwkwardness";
	final static public String updateFpFundAwkwardness = "fpFundAwkwardness.updateFpFundAwkwardness";
	final static public String delFpFundAwkwardness = "fpFundAwkwardness.delFpFundAwkwardness";
	final static public String listFpFundAwkwardness = "fpFundAwkwardness.listFpFundAwkwardness";
	final static public String countFpFundAwkwardness = "fpFundAwkwardness.countFpFundAwkwardness";
	
	final static public String fpFundBuynotice = "fpFundBuynotice.getFpFundBuynotice";
	final static public String insertFpFundBuynotice = "fpFundBuynotice.insertFpFundBuynotice";
	final static public String updateFpFundBuynotice = "fpFundBuynotice.updateFpFundBuynotice";
	final static public String delFpFundBuynotice = "fpFundBuynotice.delFpFundBuynotice";
	final static public String listFpFundBuynotice = "fpFundBuynotice.listFpFundBuynotice";
	final static public String countFpFundBuynotice = "fpFundBuynotice.countFpFundBuynotice";
	
	final static public String fpFundCM = "fpFundCM.getFpFundCM";
	final static public String insertFpFundCM = "fpFundCM.insertFpFundCM";
	final static public String updateFpFundCM = "fpFundCM.updateFpFundCM";
	final static public String delFpFundCM = "fpFundCM.delFpFundCM";
	final static public String listFpFundCMByPage = "fpFundCM.listFpFundCMByPage";
	final static public String listFpFundCM = "fpFundCM.listFpFundCM";
	final static public String countFpFundCM = "fpFundCM.countFpFundCM";
	
	final static public String fpFundCompany = "fpFundCompany.getFpFundCompany";
	final static public String getFpFundCompanyByManagerId = "fpFundCompany.getFpFundCompanyByManagerId";
	final static public String getFpFundCompanyByFundId = "fpFundCompany.getFpFundCompanyByFundId";
	final static public String insertFpFundCompany = "fpFundCompany.insertFpFundCompany";
	final static public String updateFpFundCompany = "fpFundCompany.updateFpFundCompany";
	final static public String delFpFundCompany = "fpFundCompany.delFpFundCompany";
	final static public String listFpFundCompany = "fpFundCompany.listFpFundCompany";
	final static public String listFpFundCompanyByManagerId = "fpFundCompany.listFpFundCompanyByManagerId";
	final static public String countFpFundCompany = "fpFundCompany.countFpFundCompany";
	
	final static public String fpFundCF = "fpFundCF.getFpFundCF";
	final static public String insertFpFundCF = "fpFundCF.insertFpFundCF";
	final static public String updateFpFundCF = "fpFundCF.updateFpFundCF";
	final static public String delFpFundCF = "fpFundCF.delFpFundCF";
	final static public String listFpFundCFByPage = "fpFundCF.listFpFundCFByPage";
	final static public String listFpFundCF = "fpFundCF.listFpFundCF";
	final static public String countFpFundCF = "fpFundCF.countFpFundCF";
	
	final static public String fpFundInfo = "fpFundInfo.getFpFundInfo";
	final static public String insertFpFundInfo = "fpFundInfo.insertFpFundInfo";
	final static public String updateFpFundInfo = "fpFundInfo.updateFpFundInfo";
	final static public String delFpFundInfo = "fpFundInfo.delFpFundInfo";
	final static public String listFpFundInfo = "fpFundInfo.listFpFundInfo";
	final static public String listFpFundInfoByCompanyId = "fpFundInfo.listFpFundInfoByCompanyId";
	final static public String listFpFundInfoByManagerId = "fpFundInfo.listFpFundInfoByManagerId";
	final static public String countFpFundInfo = "fpFundInfo.countFpFundInfo";
	final static public String queryFundInfoNameById = "fpFundInfo.queryFundInfoNameById";
	
	final static public String fpFundMC = "fpFundMC.getFpFundMC";
	final static public String insertFpFundMC = "fpFundMC.insertFpFundMC";
	final static public String updateFpFundMC = "fpFundMC.updateFpFundMC";
	final static public String delFpFundMC = "fpFundMC.delFpFundMC";
	final static public String listFpFundMC = "fpFundMC.listFpFundMC";
	final static public String listFpFundMCByPage = "fpFundMC.listFpFundMCByPage";
	final static public String countFpFundMC = "fpFundMC.countFpFundMC";
	
	final static public String fpFundMF = "fpFundMF.getFpFundMF";
	final static public String insertFpFundMF = "fpFundMF.insertFpFundMF";
	final static public String updateFpFundMF = "fpFundMF.updateFpFundMF";
	final static public String delFpFundMF = "fpFundMF.delFpFundMF";
	final static public String listFpFundMF = "fpFundMF.listFpFundMF";
	final static public String listFpFundMFByPage = "fpFundMF.listFpFundMFByPage";
	final static public String countFpFundMF = "fpFundMF.countFpFundMF";
	
	final static public String fpFundManager = "fpFundManager.getFpFundManager";
	final static public String insertFpFundManager = "fpFundManager.insertFpFundManager";
	final static public String updateFpFundManager = "fpFundManager.updateFpFundManager";
	final static public String delFpFundManager = "fpFundManager.delFpFundManager";
	final static public String listFpFundManager = "fpFundManager.listFpFundManager";
	final static public String listFpFundManagerByCompanyId = "fpFundManager.listFpFundManagerByCompanyId";
	final static public String listFpFundManagerByFundId = "fpFundManager.listFpFundManagerByFundId";
	final static public String countFpFundManager = "fpFundManager.countFpFundManager";

	
	/**
	 * 添加黑名单
	 */
	final static public String addBlacklist = "faUserBlacklist.addBlacklist";
	
	/**
	 * 查询黑名单
	 */
	final static public String queryBlacklist = "faUserBlacklist.queryBlacklist";
	/**
	 * 查询黑名单数量
	 */
	final static public String queryBlacklistCount = "faUserBlacklist.queryBlacklistCount";
	
	/**
	 * 添加黑名单
	 */
	final static public String queryBlacklistByUserId = "faUserBlacklist.queryBlacklistByUserId";
	

	/**
	 * 权限转移
	 */
	final static public String fpProjectTransferHis = "fpProjectTransferHis.getFpProjectTransferHis";
	final static public String insertFpProjectTransferHis = "fpProjectTransferHis.insertFpProjectTransferHis";
	final static public String updateFpProjectTransferHis = "fpProjectTransferHis.updateFpProjectTransferHis";
	final static public String delFpProjectTransferHis = "fpProjectTransferHis.delFpProjectTransferHis";
	final static public String listFpProjectTransferHis = "fpProjectTransferHis.listFpProjectTransferHis";
	final static public String countFpProjectTransferHis = "fpProjectTransferHis.countFpProjectTransferHis";
	final static public String fpProjectTransferHisGetUserName = "fpProjectTransferHis.getUserName";
	final static public String getTransferUserNameByProjectID = "fpProjectTransferHis.getTransferUserNameByProjectID";
	
	/**
	 * 查询快速预约订单
	 */
	final static public String queryOrderTmpList = "ordertmp.queryOrderTmpList";
	/**
	 * 查询快速预约订单 根据产品
	 */
	final static public String queryOrderTmpByProList = "ordertmp.queryOrderTmpByProductIdList";
	/**
	 * count查询快速预约订单 根据产品
	 */
	final static public String countOrderTmpByProList = "ordertmp.countOrderTmpByProductIdList";
	
	/**
	 * 查询快速预约订单总数
	 */
	final static public String queryOrderTmpCount = "ordertmp.queryOrderTmpCount";
	
	/**
	 * 更新快速预约订单状态
	 */
	final static public String updateOrderTmp = "ordertmp.updateOrderTmp";
	
	/**
	 * 百万财富计划活动查询
	 */
	final static public String queryActivitiesMollionsWealth = "activitesMollionsWealth.queryActivitiesMollionsWealth";
	
	/**
	 * 百万财富计划活动产品总数
	 */
	final static public String queryActivitiesMollionsWealthCount = "activitesMollionsWealth.queryActivitiesMollionsWealthCount";
	
	/**
	 * 百万财富计划 产品添加
	 */
	final static public String addActivitiesMollionsWealthProduct = "activitesMollionsWealth.addActivitiesMollionsWealthProduct";

	/**
	 * 百万财富计划产品更新
	 */
	final static public String updateActivitiesMollionsWealthProduct = "activitesMollionsWealth.updateActivitiesMollionsWealthProduct";
	/**
	 * 删除百万财富计划产品 （活动关联表）
	 */
	final static public String deleteActivitiesMollionsWealth = "activitesMollionsWealth.deleteActivitiesMollionsWealth";
	
	
	/**
	 * 查询code获取活动信息
	 */
	public final static String activitesSearchByCode = "activites.searchActivitesByCode";
	
	/**
	 * 查询活动扩展表
	 */
	public final static String activitesSearchExpand = "activites.searchActivitesExpand";
	
	/**
	 * 更新活动已发放总金额
	 */
	public final static String activitesUpdateNowAmount = "activites.activitesUpdateNowAmount";
	/**
	 * 
	 */
	public final static String insertActivitesBwcfjh = "activites.insertActivitesBwcfjh";
	/**
	 * 查询活动扩展表
	 */
	public final static String queryActivitesBwcfjhList = "activites.queryActivitesBwcfjhList";
	/**
	 * 查询活动扩展表
	 */
	public final static String queryActivitesBwcfjhInfo = "activites.queryActivitesBwcfjhInfo";
	/**
	 * 查询活动扩展表
	 */
	public final static String updateActivitesBwcfjh = "activites.updateActivitesBwcfjh";
	/**
	 * 添加产品供应商
	*/

	final static public String addProjectSupplier = "projectsupplier.addProjectSupplier";
	
	/**
	 * 更新产品供应商
	 */
	final static public String updateProjectSupplier = "projectsupplier.updateProjectSupplier";
	
	/**
	 * 查询产品供应方信息
	 */
	final static public String queryProjectSupplierInfo = "projectsupplier.queryProjectSupplierInfo";
	
	/**
	 * 查询产品供应方列表
	 */
	final static public String queryProjectSupplierList = "projectsupplier.queryProjectSupplierList";
	
	/**
	 * 查询产品供应方总数
	 */
	final static public String queryProjectSupplierCount = "projectsupplier.queryProjectSupplierCount";
	
	/**
	 * 删除产品供应方
	 */
	final static public String delProjectSupplier = "projectsupplier.delProjectSupplier";
	/**
	 * 新增产品供应方修改历史记录
	 */
	final static public String insertProjectSupplierFlow = "projectsupplierflow.addProjectSupplierFlow";
	
	/**
	 * 查询产品供应方修改历史记录
	 */
	final static public String queryProjectSupplierFlowList = "projectsupplierflow.queryProjectSupplierFlowList";
	
	/**
	 * 查询产品供应方修改历史记录总条数
	 */
	final static public String queryProjectSupplierFlowCount = "projectsupplierflow.queryProjectSupplierFlowCount";
	
	/**
	 * 活动中奖记录
	 */
	final static public String addActivitiesWinList = "activitiesWinList.addActivitiesWinList";
	final static public String deleteActivitiesWinList = "activitiesWinList.deleteActivitiesWinList";
	final static public String queryActivitiesWinListCount = "activitiesWinList.queryActivitiesWinListCount";
	final static public String queryActivitiesWinListList = "activitiesWinList.queryActivitiesWinListList";

	/**
	 * 产品深度分析
	 */
	final static public String getFpProductDeepAnalytics = "fpProductDeepAnalytics.getFpProductDeepAnalytics";
	final static public String insertFpProductDeepAnalytics = "fpProductDeepAnalytics.insertFpProductDeepAnalytics";
	final static public String updateFpProductDeepAnalytics = "fpProductDeepAnalytics.updateFpProductDeepAnalytics";
	final static public String insertFpProductDeepAnalyticsHis = "fpProductDeepAnalytics.insertFpProductDeepAnalyticsHis";

	/**
	 * 添加短信广告模块
	 */
	final static public String addSMSAD = "messageSms.addSMSAD";
	
	/**
	 * 查询短信广告模块
	 */
	final static public String querySMSADList= "messageSms.querySMSADList";
	
	/**
	 * 删除短信广告模块
	 */
	final static public String deleteSMSAD = "messageSms.deleteSMSAD";
	
	/**
	 * 查询单个短信广告
	 */
	final static public String querySMSADInfo = "messageSms.querySMSADInfo";

	/**
	 * 根据模板代码查询模板
	 */
	final static public String queryEmailTemplateByType = "emailTemplate.queryEmailTemplateByType";
	
	/**
	 * 邮件推荐 推荐的产品
	 */
	final static public String queryEmailProjectRecommendList = "productRecommend.queryEmailProjectRecommendList";
	
	/**
	 * 邮件推荐产品
	 */
	final static public String queryEmailProjectList= "productRecommend.queryEmailProjectList";
	
	/**
	 * 查询需要发送产品推荐邮件的FA
	 */
	final static public String queryFaUserVPassEmail = "faUser.queryFaUserVPassEmail";
	
	/**
	 * 查询子用户id
	 */
	final static public String queryFaUserSubUserId = "faUser.queryFaUserSubUserId";
	/**
	 * 查询需要发送工作人员的订单
	 */
	final static public String queryFaOrderPerForEmail =  "order.queryFaOrderPerForEmail";
	
	/**
	 * 根据产品IDs,查询信息
	 */
	final static public String queryInfoByOrderIds =  "order.queryInfoByOrderIds";
	
	/**
	 * 查询临时订单发送邮件给工作人员
	 */
	final static public String queryFaOrderPerTmpForEmail = "ordertmp.queryFaOrderPerTmpForEmail";
	
	/**
	 * 根据私募订单查询私募信息
	 */
	final static public String queryInfoByOrderTmpIds = "ordertmp.queryInfoByOrderTmpIds";
	
	final static public String insertHs300="hs300.insertHs300";
	/**
	 * 插入产品需要附件
	 */
	final static public String insertProductOrderData="productOrderData.insertProductOrderData";
	/**
	 * 删除产品需要附件
	 */
	final static public String delProductOrderData="productOrderData.delProductOrderData";
	/**
	 * 查询产品需要附件
	 */
	final static public String queryProductOrderData="productOrderData.queryProductOrderData";
	/**
	 * 查询产品需要附件
	 */
	final static public String queryOrderPho="orderPho.queryOrderPho";
	/**
	 * 删除产品需要附件
	 */
	final static public String deleteOrderPhoStatus="orderPho.deleteOrderPhoStatus";
	/**
	 * 新增产品需要附件
	 */
	final static public String addOrderPho="orderPho.addOrderPho";
	/**
	 * 查询产品是否全部审核通过附件
	 */
	final static public String queryOrderPhoConfirm="orderPho.queryOrderPhoConfirm";
	/**
	 * 查询私募产品是否全部审核通过附件
	 */
	final static public String queryOrderTmpConfirm="orderPho.queryOrderTmpConfirm";
	/**
	 *修改产品需要附件
	 */
	final static public String updateOrderPho="orderPho.updateOrderPho";
	/**
	 * 新增订单管理员
	 */
	final static public String addOrderManagerUser = "orderManager.addOrderManagerUser";
	
	/**
	 * 新增订单管理员
	 */
	final static public String deleteOrderManagerUser = "orderManager.deleteOrderManagerUser";
	
	/**
	 * 
	 */
	final static public String queryBySystemUserId = "orderManager.queryBySystemUserId";
	
	/**
	 * 查询所有的订单管理员
	 */
	final static public String queryOrderManagerUsers = "orderManager.queryOrderManagerUsers";
	
	/**
	 * 
	 */
	final static public String queryCountOfOrderManagerUsers = "orderManager.queryCountOfOrderManagerUsers";
	
	/**
	 * 查询还未添加到订单管理员的
	 */
	final static public String queryNotOrderManagerUsers = "orderManager.queryNotOrderManagerUsers";
	
	/**
	 * 查询还未添加到订单管理员的数量
	 */
	final static public String queryCountOfNotOrderManagerUsers = "orderManager.queryCountOfNotOrderManagerUsers";
	
	/**
	 * 给订单管理员分配订单
	 */
	final static public String addManagerOrderUser = "managerOrder.addManagerOrderUser";
	final static public String addManagerOrderUserHistory = "managerOrder.addManagerOrderUserHistory";
	/**
	 * 订单管理权限修改 
	 */
	final static public String updateManagerOrderUser = "managerOrder.updateManagerOrderUser";
	
	final static public String queryManagerOrderByOrderIds = "managerOrder.queryManagerOrderByOrderIds";
	final static public String queryManagerOrderByOrderTmpIds = "managerOrder.queryManagerOrderByOrderTmpIds";
	final static public String queryManagerOrderByUser = "managerOrder.queryManagerOrderByUser";
	/**
	 * 根据订单人员ID查询理财师
	 */
	final static public String queryFaUserBySystemUser = "managerOrder.queryFaUserBySystemUser";
	
	/**
	 * 订单通知
	 */
	final static public String queryneedSendEmailToManager = "order.queryneedSendEmailToManager";
	final static public String queryneedSendEmailToManagerUser = "order.queryneedSendEmailToManagerUser";
	final static public String queryneedSendEmailToManagerUserDetail = "order.queryneedSendEmailToManagerUserDetail";
	final static public String queryneedSendEmailToManagerSM = "order.queryneedSendEmailToManagerSM";
	final static public String queryneedSendEmailToManagerUserSM = "order.queryneedSendEmailToManagerUserSM";
	final static public String queryneedSendEmailToManagerUserDetailSM = "order.queryneedSendEmailToManagerUserDetailSM";
	final static public String queryOrderManagerUserBySource = "order.queryOrderManagerUserBySource";
	//pevc订单发送邮件
	final static public String queryPevcneedSendEmailToManager="order.queryPevcneedSendEmailToManager";
	final static public String queryPEVCneedSendEmailToManagerUser = "order.queryPEVCneedSendEmailToManagerUser";
	final static public String queryPevcneedSendEmailToManagerUserDetail = "order.queryPevcneedSendEmailToManagerUserDetail";
	
	
	
	final static public String countOrdersBySUid = "managerOrder.countOrdersBySUid";
	final static public String queryOrdersBySUid = "managerOrder.queryOrdersBySUid";
	final static public String queryOrderFollowUpList = "managerOrder.queryOrderFollowUpList";
	final static public String queryOrderFollowUpAllInfoCount = "managerOrder.queryOrderFollowUpAllInfoCount";
	
	//产品视频相关sql
	final static public String queryProductVideoByProduct = "productVideo.queryProductVideoByProduct";
	final static public String deleteProductVideoByProduct ="productVideo.deleteProductVideoByProduct";
	final static public String insertProductVideo = "productVideo.insertProductVideo";
	/**
	 * 个人产品供应方
	 */
	//查询个人产品供应方
	final static public String queryProductSupplier = "productSupplier.queryProductSupplier";
	//查询个人产品供应方总数
	final static public String queryProductSupplierCount = "productSupplier.queryProductSupplierCount";
	//新增个人产品供应方
	final static public String addProductSupplier = "productSupplier.addProductSupplier";
	//编辑个人产品供应方
	final static public String updateProductSupplier = "productSupplier.updateProductSupplier";
	//查询个人产品供应方信息
	final static public String queryProductSupplierInfo = "productSupplier.queryProductSupplierInfo";
	
	/**
	 * 个人发布产品
	 */
	//查询个人发布产品
	final static public String queryforegroundProduct = "foregroundProduct.queryforegroundProduct";
	//新增个人发布产品
	final static public String addForegroundProduct = "foregroundProduct.addForegroundProduct";
	//编辑个人发布产品
	final static public String editForegroundProduct = "foregroundProduct.updateForegroundProduct";
	//统计个人发布产品
	final static public String countForegroundProduct = "foregroundProduct.countForegroundProduct";
	//个人发布产品详情
	final static public String queryForegroundProductDetail="foregroundProduct.queryForegroundProductDetail";
	//个人发布产品发送邮件
	final static public String queryForegroundProductBySendEmail = "foregroundProduct.queryForegroundProductBySendEmail";
	//  募集进度提醒短信
	final static public String queryForegroundProductBySendSMS = "foregroundProduct.queryForegroundProductBySendSMS";
	
//  募集进度后台供应方邮件通知
	final static public String queryProductSupplierInfoEmail = "productSupplier.queryProductSupplierInfoEmail";

//  募集进度后台供应方邮件通知
	final static public String queryProductSupplierEmailById = "productSupplier.queryProductSupplierEmailById";

	//插入产品成立公告
	final static public String insertproductnotice = "productnotice.insertproductnotice";
	//查询产品成立公告根据url
	final static public String queryproductnoticeUrl = "productnotice.queryproductnoticeUrl";
	//产品成立公告正则
	final static public String querytrustregex = "trustregex.querytrustregex";
	//查询所有已存在的url
	final static public String queryproductnoticeUrlList="productnotice.queryproductnoticeUrlList";
	
	//查询产品成立公告列表
	final static public String queryproductnotice="productnotice.queryproductnotice";
	//查询产品成立公告详情
	final static public String queryproductnoticeDetail="productnotice.queryproductnoticeDetail";
	//修改产品成立公告详情
	final static public String updateproductnotice="productnotice.updateproductnotice";
	//成立公告总数量
	final static public String countproductnotice="productnotice.countproductnotice";
	
		// 添加订单通知
	final static public String addFaOrderNotice = "notice.addFaOrderNotice";
	final static public String queryOrderDetailByOrderId = "notice.queryOrderDetailByOrderId";

	// 公告查询
	final static public String queryProductNotice = "productNotice.queryProductNotice";
	
	
		/**
	 * 新增理财师管理员
	 */
	final static public String addLicaishiManagerUser = "licaishiManager.addLicaishiManagerUser";
	
	/**
	 * 新增理财师管理员
	 */
	final static public String deleteLicaishiManagerUser = "licaishiManager.deleteLicaishiManagerUser";
	/**
	 * 查询所有的理财师管理员
	 */
	final static public String queryLicaishiManagerUsers = "licaishiManager.queryLicaishiManagerUsers";
	
	/**
	 * 
	 */
	final static public String queryCountOfLicaishiManagerUsers = "licaishiManager.queryCountOfLicaishiManagerUsers";
	
	/**
	 * 查询还未添加到理财师管理员的
	 */
	final static public String queryNotLicaishiManagerUsers = "licaishiManager.queryNotLicaishiManagerUsers";
	
	/**
	 * 查询还未添加到理财师管理员的数量
	 */
	final static public String queryCountOfNotLicaishiManagerUsers = "licaishiManager.queryCountOfNotLicaishiManagerUsers";
	/**
	 *  根据理财师查询  管理员
	 */
	final static public String queryLicaishiManagerUsersByUid = "licaishiManager.queryLicaishiManagerUsersByUid";
	
	/**
	 * 分配理财师给服务顾问
	 */
	final static public String addManagerLicaishiUser = "managerLicaishi.addManagerLicaishiUser";
	final static public String addManagerLicaishiUserHistory = "managerLicaishi.addManagerLicaishiUserHistory";
	/**
	 * 理财师服务顾问权限修改 
	 */
	final static public String updateManagerLicaishiUser = "managerLicaishi.updateManagerLicaishiUser";
	final static public String queryManagerLicaishiByUser = "managerLicaishi.queryManagerLicaishiByUser";
	final static public String countManagerLicaishiByUser = "managerLicaishi.countManagerLicaishiByUser";
	final static public String queryManagerLicaishiByForFirst = "managerLicaishi.queryManagerLicaishiByForFirst";
	
	//回收理财师列表查询
	final static public String queryManagerLicaishiJob="managerLicaishi.queryManagerLicaishiJob";
	/**
	 * 订单流程改造
	 * 查询订单详情
	 */
	final static public String queryOrderByGaiZao = "order.queryOrderByGaiZao"; 
	/**
	 * 订单流程改造
	 * 查询订单列表
	 */
	final static public String queryOrderListByGaiZao = "order.queryOrderListByGaiZao"; 
	/**
	 * 订单流程改造
	 * 查询订单基本信息
	 */
	final static public String queryOrderBaseInfoByGaiZao = "order.queryOrderBaseInfoByGaiZao"; 
	/**
	 * 订单流程改造
	 * 查询订单条数
	 */
	final static public String queryOrderCountByGaiZao = "order.queryOrderCountByGaiZao"; 
	/**
	 * 订单流程改造
	 * 更新订单
	 */
	final static public String updateOrderByGaiZao = "order.updateOrderByGaiZao"; 
	
	/**
	 * 查询所有的订单负责人
	 */
	final static public String queryOrderOwnerUserList = "order.queryOrderOwnerUserList";
	/**
	 * 插入产品流水 订阅通知、产品信息
	 */
	final static public String addProjectFlow ="project.addProjectFlow";
	/**
	 * 查询单个产品流水相关
	 */
	final static public String searchProjectBypId ="project.searchProjectBypId";
	
	/**
	 * 新增产品绑定来源
	 */
	final static public String insertSourceProduct ="sourceProductControl.insertSourceProduct";
	/**
	 * 删除产品绑定来呀
	 */
	final static public String deleteSourceProduct ="sourceProductControl.deleteSourceProduct";
	/**
	 * 查询产品绑定来呀
	 */
	final static public String querySourceProduct ="sourceProductControl.querySourceProduct";
	// 根据loginName查询FAID
	final static public String queryFaIdByLoginName = "faUserVisit.queryFaIdByLoginName";
	/**
	 * 新增推荐产品
	 */
	final static public String insertRecommentProduct ="recommentProductControl.insertRecommentProduct";
	/**
	 * 删除推荐产品
	 */
	final static public String deleteRecommentProduct ="recommentProductControl.deleteRecommentProduct";
	/**
	 * 查询推荐产品
	 */
	final static public String queryRecommentProduct ="recommentProductControl.queryRecommentProduct";
	/**
	 * 查询推荐产品
	 */
	final static public String queryRecommentProductCount ="recommentProductControl.queryRecommentProductCount";
	
	/**
	 *  更新最近访问时间
	 */
	final static public String updateLastVisitTime = "faUserVisit.updateLastVisitTime";
	
	final static public String order2Leader = "managerOrder.order2Leader";
	
	/**
	 * 查询组团1000活动团信息
	 */
	final static public String queryActivitiesGroupInfo = "activitiesGroup.queryActivitiesGroupInfo";

	/**
	 * 查询组团1000活动团信息 count
	 */
	final static public String queryActivitiesGroupInfoCount = "activitiesGroup.queryActivitiesGroupInfoCount";
	
	/**
	 * 更新组团1000活动信息
	 */
	final static public String updateActivitiesGroup = "activitiesGroup.updateActivitiesGroup";
	
	/**
	 * 根据手机号查询用户id
	 */
	final static public String queryFaUserByMoblie = "faUser.queryFaUserByMoblie";
	
	/**
	 * 查询组是否已经领过红包
	 */
	final static public String queryFaHadGetGroupGift = "activitiesGroup.queryFaHadGetGroupGift";
	
	/**
	 * 查询认证通过团成员
	 */
	final static public String queryActivitiesGroupAuthMember = "activitiesGroup.queryActivitiesGroupAuthMember";
	
	/**
	 * 查询团认证通过成员
	 */
	final static public String queryactGroupList  = "activitiesGroup.queryactGroupList";
	
	
	/**
	 * 新增抓取产品
	 */
	final static public String insertFpNewProduct  = "fpNewProductControl.insertFpNewProduct";
	/**
	 * 查询抓取产品  根据url  单个
	 */
	final static public String queryFpNewProduct  = "fpNewProductControl.queryFpNewProduct";
	/**
	 * 查询Id 单个
	 */
	final static public String queryFpNewProductDetailById  = "fpNewProductControl.queryFpNewProductDetailById";
	
	/**
	 * 查询抓取产品   不同的 列表
	 */
	final static public String queryFpNewProductList  = "fpNewProductControl.queryFpNewProductList";
	/**
	 * 查询抓取产品   不同的 列表count
	 */
	final static public String countFpNewProductList  = "fpNewProductControl.countFpNewProductList";
	
	/**
	 * 更新抓取产品  
	 */
	final static public String updateFpNewProduct  = "fpNewProductControl.updateFpNewProduct";
	/**
	 *  查询SFA未绑定产品列表 
	 */
	final static public String noBindProjectList  = "fpNewProductControl.noBindProjectList";
	
	/**
	 *  查询SFA已绑定产品列表 
	 */
	final static public String bindProjectList  = "fpNewProductControl.bindProjectList";
	
	/**
	 *  查询SFA已绑定产品列表 count
	 */
	final static public String bindProjectListCount  = "fpNewProductControl.bindProjectListCount";
	
	/**
	 *放弃抓取产品
	 */
	final static public String deleteFpNewProduct  = "fpNewProductControl.deleteFpNewProduct";
	
	/**
	 *更新SFA产品募集进度
	 */
	final static public String updatepRecruitmentSummaryById  = "fpNewProductControl.updatepRecruitmentSummaryById";
	/**
	 *更新抓取产品更新状态
	 */
	final static public String updateStatus  = "fpNewProductControl.updateStatus";

	/**
	 *新增抓取产品和SFA产品关联关系  
	 */
	final static public String insertFpRelevance  = "fpRelevanceControl.insertFpRelevance";
	
	/**
	 *查询抓取产品和SFA产品关联关系  
	 */
	final static public String queryFpRelevance  = "fpRelevanceControl.queryFpRelevance";
	
	/**
	 *解除产品绑定关系
	 */
	final static public String deleteFpRelevance  = "fpRelevanceControl.deleteFpRelevance";
	
	// 三方公司索引相关 by cuimo
	/**
	 * 添加产品公司
	 */
	final static public String addThirdPartyCompany = "thirdPartyCompany.addThirdPartyCompany";
	/**
	 * 修改产品公司
	 */
	final static public String updateThirdPartyCompany = "thirdPartyCompany.updateThirdPartyCompany";
	/**
	 * 查询产品公司列表
	 */
	final static public String queryThirdPartyCompany = "thirdPartyCompany.queryThirdPartyCompany";
	/**
	 * 查询产品公司列表总
	 */
	final static public String queryThirdPartyCompanyCount = "thirdPartyCompany.queryThirdPartyCompanyCount";
	/**
	 * 查询产品公司列表总
	 */
	final static public String delThirdPartyCompany = "thirdPartyCompany.delThirdPartyCompany";
	
		/**
	 * 新增有单金额明细
	 */
	final static public String insertYouDanAmount  = "youDanAmount.insertYouDanAmount";
	/**
	 * 更新有单金额明细
	 */
	final static public String updateYouDanAmount  = "youDanAmount.updateYouDanAmount";
	/**
	 * 查询有单金额明细
	 */
	final static public String queryBiddingReceiptSuccess  = "fpBiddingReceipt.queryBiddingReceiptSuccess";
	
	/**
	 *根据产品ID查询 当前竞价rebate 返佣信息
	 */
	final static public String queryBiddingReceiptSuccessRebate  = "fpBiddingReceipt.queryBiddingReceiptSuccessRebate";
	
	//新增竞价
	final static public String addFpBiddingReceipt="fpBiddingReceipt.addFpBiddingReceipt";
	
	//新增竞价关联
	final static public String addFpBiddingRevenue="fpBiddingReceipt.addFpBiddingRevenue";
	
	//新增竞价关联
	final static public String queryFpBiddingRevenueList="fpBiddingReceipt.queryFpBiddingRevenueList";
	
	//查询竞价信息
	final static public String queryBiddingReceipt="fpBiddingReceipt.queryBiddingReceipt";
	
	
	
	//查询需要解冻的竞价保证金
	final static public String queryUnFreezingBailList="fpBiddingReceipt.queryUnFreezingBailList";
	final static public String getYouDanAmount  = "youDanAmount.getYouDanAmount";
	/**
	 *查询产品竞价列表
	 */
	final static public String queryFpBiddingReceipt  = "fpBiddingReceipt.queryFpBiddingReceipt";
	/**
	 *查询产品竞价详情
	 */
	final static public String queryFpBiddingReceiptDetail  = "fpBiddingReceipt.queryFpBiddingReceiptDetail";
	/**
	 *查询产品竞价列表count
	 */
	final static public String queryFpBiddingReceiptCount  = "fpBiddingReceipt.queryFpBiddingReceiptCount";
	/**
	 *审核产品竞价
	 */
	final static public String updateBiddingReceipt  = "fpBiddingReceipt.updateBiddingReceipt";
	/**
	 * 钱包提现相关
	 */
	final static public String getYouDanWithdrawListCount  = "youDanAmount.getYouDanWithdrawListCount";
	final static public String getYouDanWithdrawList  = "youDanAmount.getYouDanWithdrawList";
	//支付流水
	public class PaymentSql{
		
		private static final String PAYMENT = "payment.";
		
		public static final String addPayment = PAYMENT+"addPayment";
		public static final String queryPayment = PAYMENT+"queryPayment";
		public static final String updatePayment = PAYMENT+"updatePayment";
		public static final String queryPaymentList = PAYMENT+"queryPaymentList";
		public static final String queryPaymentListCount = PAYMENT+"queryPaymentListCount";
		public static final String addPaymentbaofoorsp = PAYMENT+"addPaymentbaofoorsp";//宝付支付响应
	}
	/**
	 * 有单查询userINnfo卡信息
	 */
	final static public String queryFaUserBankInfo  = "youDanAmount.queryFaUserBankInfo";
	
	//线下用户
	public class OfflineUserSql{
		
		private static final String FAOFFLINEUSER = "faOfflineUser.";
		
		public static final String insertFaOfflineUsery = FAOFFLINEUSER+"insertFaOfflineUsery";
		public static final String queryFaOfflineUser = FAOFFLINEUSER+"queryFaOfflineUser";
		public static final String updateFaOfflineUser = FAOFFLINEUSER+"updateFaOfflineUser";
		public static final String queryFaOfflineUserList = FAOFFLINEUSER+"queryFaOfflineUserList";
		public static final String queryFaOfflineUserCount = FAOFFLINEUSER+"queryFaOfflineUserCount";
		public static final String queryFpFaUser = FAOFFLINEUSER+"queryFpFaUser";
	}

	
	/**
	* @ClassName: projectActivitiesSql
	* @Description: 产品活动
	 */
	public class projectActivitiesSql {
		private static final String PROJECTACTIVITIES = "projectActivities.";
		
		public static final String insertProjectActivities = PROJECTACTIVITIES+"insertProjectActivities";
		public static final String queryProjectActivities = PROJECTACTIVITIES+"queryProjectActivities";
		public static final String queryProjectActivitiesCount = PROJECTACTIVITIES+"queryProjectActivitiesCount";
		public static final String updateProjectActivities = PROJECTACTIVITIES+"updateProjectActivities";
	}
		
	/**
	 * 查询极光推送消息
	 */
	public static final String queryMessageJpush = "messageJpush.queryMessageJpush";
	
	/**
	 * 极光推送定时任务查询
	 */
	public static final String queryMessageJpushForJob = "messageJpush.queryMessageJpushForJob";

	/**
	 * 更新极光推送消息
	 */
	public static final String updateMessageJpush = "messageJpush.updateMessageJpush";

	/**
	 * 添加极光推送消息
	 */
	public static final String addMessageJpush = "messageJpush.addMessageJpush";
	
	/**
	 * 查询极光推送消息总条数
	 */
	public static final String queryMessageJpushCount = "messageJpush.queryMessageJpushCount";

	/**
	 * 查询非有单订单下的提现情况
	 */
	final static public String queryCommonOrderAmountByAssociationId  = "youDanAmount.queryCommonOrderAmountByAssociationId";
	
	/**
	 * 查询用户设备号
	 */
	public static final String queryJpushUserPhonealias = "messageJpush.queryJpushUserPhonealias";
	
	
	public class ProductRegexSql{
		
	private static final String FPFETCHPRODUCTREGEX = "fpfetchProductRegex.";
		
	public static final String queryFetchXpath = FPFETCHPRODUCTREGEX+"queryFetchXpath";
	public static final String queryAllFetchXpath = FPFETCHPRODUCTREGEX+"queryAllFetchXpath";
	public static final String updateFetchXpath = FPFETCHPRODUCTREGEX+"updateFetchXpath";
	}
	
	public class ClientSql{
		
		/**
		 * 命名空间：客户管理
		 */
		private static final String CLIENT_NAMESPACE = "client.";
			
		/**
		 *更新客户消息
		 */
		public static final String CLIENT_USER_UPDATE= CLIENT_NAMESPACE + "updateClientUserBaseById";
	
	}

	//路演视频
	public class FpVideoSql{
			
			private static final String namespace = "fpVideo.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryVideoInfo = namespace+"queryVideoInfo";
			
			public static final String updateFpVideoPassword = namespace+"updateFpVideoPassword";
			
			public static final String updateFpVideoForProduct = namespace+"updateFpVideoForProduct";
			
			
	}
	//sfa活动-金融相亲表
		public class FpHdFinancingBlindSql{
				
				private static final String namespace = "fpHdFinancingBlind.";
				
				public static final String insert = namespace+"insert";
				
				public static final String update = namespace+"update";
				
				public static final String updateForce = namespace+"updateForce";
				
				public static final String queryList = namespace+"queryList";
				
				public static final String queryListCount = namespace+"queryListCount";
				
				public static final String loadById = namespace+"loadById";
				
				public static final String delete = namespace+"delete";
		}
		//文件记录表
		public class FpFileRecordSql{
				
				private static final String namespace = "fpFileRecord.";
				
				public static final String insert = namespace+"insert";
				
				public static final String update = namespace+"update";
				
				public static final String updateForce = namespace+"updateForce";
				
				public static final String queryList = namespace+"queryList";
				
				public static final String queryListCount = namespace+"queryListCount";
				
				public static final String loadById = namespace+"loadById";
				
				public static final String delete = namespace+"delete";
		}
	//理财师-合同管理
	public class FpFaUserContractSql{

		private static final String namespace = "fpFaUserContract.";

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	//订单费用表(打款结佣)
	public class FpOrderCostSql{

		private static final String namespace = "fpOrderCost.";

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
		//金融指数日志
		public class CompositeIndexLogSql{
				
				private static final String namespace = "compositeIndexLog.";
				
				public static final String insert = namespace+"insert";
				
				public static final String update = namespace+"update";
				
				public static final String updateForce = namespace+"updateForce";
				
				public static final String queryList = namespace+"queryList";
				
				public static final String queryListCount = namespace+"queryListCount";
				
				public static final String loadById = namespace+"loadById";
				
				public static final String delete = namespace+"delete";
		}
	//业务数据日志
	public class FpOrderBizLogSql{

		private static final String namespace = "fpOrderBizLog.";

		public static final String insert = namespace+"insert";

		public static final String update = namespace+"update";

		public static final String updateForce = namespace+"updateForce";

		public static final String queryList = namespace+"queryList";

		public static final String queryListCount = namespace+"queryListCount";

		public static final String loadById = namespace+"loadById";

		public static final String delete = namespace+"delete";
	}
	
	//用户答题表
	public class FpShopSubjectUserSql{
			
			private static final String namespace = "fpShopSubjectUser.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}

	//用户反馈
	public class FpFaUserFeedbackSql{
			
			private static final String namespace = "fpFaUserFeedback.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//店铺题目表
	public class FpShopSubjectSql{
			
			private static final String namespace = "fpShopSubject.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//背景图片表
	public class FpShopBackgroundSql{
			
			private static final String namespace = "fpShopBackground.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	
	//shop人员信息表
	public class FpFaUserDataSql{
			
			private static final String namespace = "fpFaUserData.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//FA人员信息表
	public class FpFaUserSql{
			
			private static final String namespace = "fpFaUser.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			public static final String queryBYAllSum = namespace+"queryBYAllSum";
			
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String queryBySfaCount = namespace+"queryBySfaCount";
			
			public static final String queryBySfaTimeCount = namespace+"queryBySfaTimeCount";
			
			public static final String queryByJcsCount = namespace+"queryByJcsCount";
			
			public static final String queryBySfaNowDayRole1 = namespace+"queryBySfaNowDayRole1";
			
			public static final String queryListByAuthDate = namespace+"queryListByAuthDate";
			
			public static final String queryListCountByUshopRole = namespace+"queryListCountByUshopRole";
			
			
			public static final String loadById = namespace+"loadById";

			public static final String queryUserCount = namespace+"queryUserCount";

			public static final String delete = namespace+"delete";
			
			public static final String queryByMobile = namespace+"queryByMobile";
			
			public static final String queryActivityCount = namespace+"queryActivityCount";
			
			public static final String queryAllByAuthDate = namespace+"queryAllByAuthDate";
			
	}
	
	//金策师资讯
	public class FpShopInformationSql{
		
		private static final String namespace = "fpShopInformation.";
		
		public static final String insert = namespace+"insert";
		
		public static final String update = namespace+"update";
		
		public static final String updateForce = namespace+"updateForce";
		
		public static final String queryList = namespace+"queryList";
		
		public static final String queryListCount = namespace+"queryListCount";
		
		public static final String loadById = namespace+"loadById";
		
		public static final String delete = namespace+"delete";
    }
	//用户奖励流水
	public class WxUserRewardLogSql{
			
			private static final String namespace = "wxUserRewardLog.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			//奖励金额 
			public static final String loadAllMoneyById = "commonActivity.loadAllMoneyById";
			
			// 达到可提现门槛的金额 
			public static final String loadRewardMoney = "commonActivity.loadRewardMoney";
			
			public static final String queryEarlyWarningMoney = "commonActivity.queryEarlyWarningMoney";

	}
		
	//直接粉丝数
	public static final String countzjFensi = "commonActivity.countzjFensi";
	//间接粉丝数
	public static final String countjjFensi = "commonActivity.countjjFensi";
	//用户表
	public class WxUserInfoSql{
			
			private static final String namespace = "wxUserInfo.";
			
			public static final String insert = namespace+"insert";
			
			public static final String queryListAndRole = namespace+"queryListAndRole";
			
			public static final String loadByUserPhone = namespace+"loadByUserPhone";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//提现流水表
	public class WxWithdrawLogSql{
			
			private static final String namespace = "wxWithdrawLog.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryAndFaUser = namespace+"queryAndFaUser";
			
			public static final String sunDraw = namespace+"sunDraw";
			
	}
    //抓取资讯表
	public class FetchInformationSql{
			
			private static final String namespace = "fetchInformation.";
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryFetchInfoList = namespace+"queryFetchInfoList";
	}
  
	//客户发送短信待办事项流水
	public class FaRevisitTaskSql{
			
			private static final String namespace = "faRevisitTask.";
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//销售抽奖人数
	public class SalesPrizesPeopleSql{
			
			private static final String namespace = "salesPrizesPeople.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
	}
	
	public class FpFaTotalSql{
			
			private static final String namespace = "fpFaTotal.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//抽奖记录
	public class SalesPrizesLogSql{
			
			private static final String namespace = "salesPrizesLog.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//奖项配置表
	public class SalesPrizesSql{
			
			private static final String namespace = "salesPrizes.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//金策师直播平台开通申请
	public class FpShopPlayopenApplySql{
			
			private static final String namespace = "fpShopPlayopenApply.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//产品审核流水
	public class ProductCheckLogSql{
			
			private static final String namespace = "productCheckLog.";
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	
	//店铺信息表
	public class WxShopInfoSql{
			
			private static final String namespace = "wxShopInfo.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
	}
	//自动分配流水
	public class FaAutoRegisterToManagerSql{
			
			private static final String namespace = "faAutoRegisterToManager.";
			
			public static final String insert = namespace+"insert";
			
			public static final String update = namespace+"update";
			
			public static final String updateForce = namespace+"updateForce";
			
			public static final String queryList = namespace+"queryList";
			
			public static final String queryListCount = namespace+"queryListCount";
			
			public static final String loadById = namespace+"loadById";
			
			public static final String delete = namespace+"delete";
			
			public static final String queryAutoUser = namespace+"queryAutoUser";
			
			public static final String queryCurrentMonthUser = namespace+"queryCurrentMonthUser";
			
			
			
	}
	
	
	//小程序消息通知
			public class XcxNewsSql{
					
					private static final String namespace = "xcxNews.";
					
					public static final String insert = namespace+"insert";
					
					public static final String update = namespace+"update";
					
					public static final String updateForce = namespace+"updateForce";
					
					public static final String queryList = namespace+"queryList";
					
					public static final String queryListCount = namespace+"queryListCount";
					
					public static final String loadById = namespace+"loadById";
					
					public static final String delete = namespace+"delete";
			}
	//产品系列常量
	public class FpProjectSeriesSql{
		
		private static final String namespace = "fpProjectSeries.";
		
		public static final String insert = namespace+"insert";
		
		public static final String update = namespace+"update";
		
		public static final String updateForce = namespace+"updateForce";
		
		public static final String queryList = namespace+"queryList";
		
		public static final String queryListCount = namespace+"queryListCount";
		
		public static final String loadById = namespace+"loadById";
		
		public static final String delete = namespace+"delete";
		
		public static final String deleteByProSeriesName = namespace+"deleteByProSeriesName";
    }
	
	
	
	//小程序产品关键字搜索未果结果记录
			public class XcxSearchnoRecordSql{
					
					private static final String namespace = "xcxSearchnoRecord.";
					
					public static final String insert = namespace+"insert";
					
					public static final String update = namespace+"update";
					
					public static final String updateForce = namespace+"updateForce";
					
					public static final String queryList = namespace+"queryList";
					
					public static final String queryListCount = namespace+"queryListCount";
					
					public static final String loadById = namespace+"loadById";
					
					public static final String delete = namespace+"delete";
					
					public static final String queryAllList = namespace+"queryAllList";
					
					public static final String updateByKeyword = namespace+"updateByKeyword";
			}
}